SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023865 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023865 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839831,267347,248853,644299,634382,625291,877064,956014,329062,575284,99149,822262,950643,120216,845961,899321,668797,952478,661530,727808,867746,898407,713467,37876,808901,293437,99677,21994,382390,923140,125737,245601,705285,417144,246451,390985,176508,411033,826142,179504,315070,186766,238526,572757,296669,838998,233750,167482,196537,432669,585125,608557,305226,357315,351951,232316,11059,885376,258406,812908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023865 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023865 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]