SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101928 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101928 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343540,535016,907044,335786,846934,565448,316556,529032,1012223,477933,298961,319487,962786,666298,803075,290590,912395,929269,814509,506010,715773,358349,621631,718809,5379,650773,25162,511432,101296,662932,966796,654566,76039,968309,612256,516749,328225,744850,159991,286275,417176,473504,875521,1044394,243030,673435,895896,303840,347998,186230,409144,478107,428673,17279,247022,258999,667953,637200,163168,1037925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]