SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514276 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514276 [ RunTime:0.002999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011579,296781,480678,414232,762037,252181,66876,1039478,133190,968824,148275,749403,847401,969793,219754,15187,760101,1047849,946087,683257,898369,39257,409043,129234,956231,305558,1001499,919889,1040887,227788,183542,644124,977980,958896,305745,584220,155664,571923,734072,950035,368124,378381,429770,243877,799823,512101,358332,151741,422243,561210,653560,838196,918480,62149,209790,1047379,806213,33203,461841,461307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]