SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409759 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409759 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010827,446537,928450,867044,416795,348837,235078,103084,743673,953368,143050,679521,682442,542576,740547,868187,842296,554963,990225,158087,522656,91131,145204,620457,387138,304134,697600,898132,690182,337319,89123,39595,183777,529387,388525,303295,640227,28398,142913,682701,115865,80135,826028,647595,21653,760794,261947,837824,616015,108590,200096,67125,861957,420049,632967,253583,770198,393146,190705,369296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409759 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409759 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]