SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495231 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495231 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428298,494150,819016,799050,100327,442426,512178,537503,1036490,719464,365606,231316,594970,34480,358587,135504,621917,569311,454006,402741,239789,671090,109562,45475,603905,908834,413771,639897,309714,687267,312617,1047311,456001,394501,82912,423564,905168,197292,107785,249688,617683,230046,426390,460443,886354,744338,935720,482854,77793,371778,615511,305109,467782,90507,5715,593775,1035364,245994,980990,1039816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]