SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500891 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500891 [ RunTime:0.002437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423107,103940,113267,681307,500573,625221,20730,39838,674232,429296,1012913,959420,696247,885778,830105,846266,262261,100298,321630,516678,392432,371734,846049,182641,132832,761475,250080,70310,241255,788695,400758,750434,908731,974401,269841,960076,360326,194650,959778,221438,718276,915335,1634,1040107,644138,122669,651518,532238,841246,172720,445385,855231,800592,1015482,979233,232460,26064,796526,895688,875526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005826s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001554s ]