SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005496 LIMIT 1 [ RunTime:0.001367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005496 [ RunTime:0.004871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008368,1041647,186899,882626,926907,90290,1006365,313474,402070,8883,840299,654275,338325,836186,1045071,547562,359324,819001,361199,1022816,404848,341440,67235,281634,955629,288664,688234,207598,545614,176850,924659,754621,169608,248522,998410,784040,947498,516229,225518,546153,333729,50115,321458,417580,835531,33024,643959,336209,802460,272640,148862,88839,180641,405646,299087,849533,211577,589636,454514,31045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001080s ]