SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514981 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514981 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381341,852929,771738,990682,679499,648693,561833,142360,192989,357716,165952,119512,359573,20742,305474,691408,768666,57161,911198,189484,318945,116392,387622,453872,874939,1019747,79141,720610,441822,199037,715614,157306,243885,9949,512342,15840,534088,28204,645077,1006396,59694,936924,251992,386554,410133,1019340,479348,147285,47030,1024423,609596,555971,1014637,391134,403216,661605,711385,34275,583155,89885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]