SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39680 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39680 [ RunTime:0.003130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519601,860232,426305,891660,524287,122860,499431,335136,768576,446630,726646,447790,709666,52923,610813,1035268,233754,83939,957652,75929,746926,290142,112601,511958,270145,85211,688689,779349,871253,637430,824601,137568,246806,325543,499532,251238,585801,622797,222828,736752,1021141,414829,928950,843444,115019,672005,525202,786801,574665,673131,82848,590019,662094,96258,719268,295656,820622,487559,812720,36920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000808s ]