SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003024s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000213 LIMIT 1 [ RunTime:0.001139s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000213 [ RunTime:0.004095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131354,132375,380872,267551,510485,763279,640847,351554,204522,943238,521035,824848,419076,1041781,696142,11607,314449,251025,202086,193273,941695,683098,320471,351989,742869,211768,532737,616468,858885,571276,411689,663936,912481,211633,790211,1038922,118461,561651,1009323,632240,452971,726895,728321,854075,57096,586926,713746,404909,624665,359959,574290,900523,425035,781163,670078,81997,839248,220436,5070,711563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001345s ]