SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642712 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642712 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681759,23855,642055,365209,848619,844195,599186,275952,471948,402848,751196,190056,670402,235175,504712,480144,519543,357470,799532,1020551,788660,1041083,30435,844478,982008,1014504,605983,797757,923068,398840,454470,507643,1009288,1017686,153088,631486,117486,145205,687569,132321,127315,881944,508753,674233,221717,307499,718738,862140,987808,850932,235906,224631,649589,332865,906717,336099,483633,302394,460900,573960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]