SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 11573 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 11573 [ RunTime:0.002223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236697,36611,682542,228643,709186,742230,287969,515427,150918,51281,371846,24561,311036,224496,546024,625262,197002,428914,649079,846673,63342,709083,491223,171148,305499,62091,879358,187764,699876,984001,88090,172131,469971,907292,817302,29799,189740,123754,765389,898738,858204,875975,109547,862,345866,628132,909550,670352,536905,211460,1019219,93304,775155,393176,818180,904304,839013,228593,530184,193576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 11573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 11573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001011s ]