SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483847 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483847 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42521,332765,393183,211486,323626,672000,911492,515834,972253,946027,219754,730646,806056,110006,365620,351399,634371,493532,417055,574103,433941,905621,476205,632289,573693,984057,536735,382299,667012,993038,768641,178766,85237,846467,854127,16785,306902,538810,36751,336431,185742,510156,1002552,791883,641467,488889,808046,769283,237660,480450,1030674,197698,586323,15963,915294,237490,4847,10633,180426,188078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]