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` = 596552 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596552 [ RunTime:0.004004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346438,1001693,878099,826998,862155,307557,149789,408071,130122,111054,163131,339792,996914,415971,32600,706199,533562,198915,55516,568647,747731,825586,499902,954913,223884,717300,118750,722809,878924,36111,65284,713165,299871,695777,278640,227111,140870,552352,454066,401310,537220,439541,104774,961829,792832,178270,964220,431262,179198,804548,3280,762194,397931,977167,966135,225746,321629,930167,524823,276114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]