SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59206 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59206 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013519,972834,777466,385262,334910,720041,203749,259664,110402,164675,226829,760587,688446,490909,11703,898392,708993,957894,174623,296844,28604,988214,705414,100985,646300,322860,850789,252166,687546,399148,317209,313749,467766,717358,301137,1011987,159653,694502,808677,107212,133196,880045,297888,844312,739765,837954,92746,675562,805068,643930,808307,825180,101542,982604,393352,51042,827287,484566,970781,277228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]