SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535394 LIMIT 1 [ RunTime:0.000271s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535394 [ RunTime:0.003029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943748,468668,158418,12867,653126,427334,980360,673623,718012,319505,112422,514446,58280,443940,274697,791920,875340,371403,8567,29704,589085,156798,109430,547913,10184,745754,682659,52197,489663,173663,601954,201958,304750,190308,144784,720330,422150,698261,332677,870590,736906,522706,381827,730395,255608,896580,588983,678657,632327,163035,766024,546300,733035,701372,660725,277896,277730,535243,196361,794715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]