SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51970 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51970 [ RunTime:0.003699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962183,429039,154201,23428,900965,525137,720829,679446,908757,1014353,583497,408118,132831,161066,615942,351841,301756,102271,1014567,645308,12720,64274,9485,948812,813428,92857,996149,205950,650102,404883,928574,222353,355402,524686,236429,76053,963000,551290,55698,291724,830394,1024526,453368,787338,283192,726474,234157,574202,402020,202244,417389,641768,349868,1008834,108176,617684,652764,634069,985644,499410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002196s ]