SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562260 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562260 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642450,499472,221776,457586,187498,901805,918423,412156,328685,433488,1044854,831829,741782,345614,1000949,823400,270667,728794,554742,462221,142176,564230,987696,343485,260511,37177,258665,630619,328882,464925,244707,896866,190352,36846,733579,1002260,46794,607434,618988,54826,815263,768330,608033,677548,879668,167490,989260,196745,710194,197906,191002,259568,151989,566492,649798,33846,815000,394303,287510,591460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]