SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107022 LIMIT 1 [ RunTime:0.001703s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107022 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814964,653996,1036128,1025731,927601,888898,115562,495440,827118,988058,814614,238085,344758,681876,823699,994119,485964,970294,654844,303053,563541,475862,886858,534578,264519,418701,247753,678747,597128,453688,496446,66691,2181,412259,599715,490145,700815,135773,76090,1033174,421774,270968,415932,224208,358503,368329,559810,2419,678592,939014,715325,1020576,695327,472059,415763,803451,868409,454960,653454,19517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]