SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481045 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481045 [ RunTime:0.002345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559763,813527,287718,280010,166800,239470,584488,584336,640356,75294,459403,216052,392551,551180,855277,801540,763409,942590,898391,385981,213183,451097,794068,853070,770851,4093,199242,836695,78874,619961,550527,728462,128211,993863,731412,865579,839597,625339,184365,419107,632489,239269,1042793,266100,236386,22369,726154,746429,579165,1041070,832978,110368,966958,107097,757350,154485,220352,454833,181013,228059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]