SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262589 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262589 [ RunTime:0.002468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907999,710205,352774,621712,296988,367004,696764,375357,515066,244106,321465,1017469,516836,219610,52658,640970,837715,800507,134952,595110,921295,220348,557535,402074,605940,255987,769806,241796,192962,691783,610765,104907,613032,479774,641803,800231,802678,836268,694707,480562,291834,632420,288073,1011140,241745,227527,406991,10182,99856,217792,406152,714276,544697,603279,732674,897164,558211,12921,528929,28363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]