SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046548 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046548 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650475,1020788,1017662,637622,652047,284684,798428,230210,672859,988872,349356,101715,326505,583177,431935,997419,519154,464388,120693,1016602,99922,571767,414830,673822,1022879,320364,680904,835091,1026661,596979,357518,450770,944004,157813,381788,887326,517871,354973,349029,897089,968414,1047025,663111,652492,41411,756559,634974,578710,57735,559680,298907,657244,712785,1042162,581915,440688,211452,479197,236293,405780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]