SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314330 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314330 [ RunTime:0.002175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68190,969841,980798,850140,442520,616384,224410,191638,243693,1015865,95253,453618,979071,744110,829395,622822,179451,290910,214836,294911,530162,143959,820809,947655,200930,791281,280377,439687,159260,484227,615702,404056,776430,352049,641328,325396,485634,91790,65088,900340,1006211,829969,792532,998335,792841,999593,956229,894015,357838,888619,852670,633843,708559,318855,318947,521699,200988,114293,930944,135514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002439s ]