SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417301 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417301 [ RunTime:0.002175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498198,606352,469529,16294,955413,491585,764996,419169,472456,471995,918641,573665,288274,507473,58980,172962,758543,243281,522133,840581,83406,467031,115765,928517,453297,753478,546093,771328,224127,847846,153185,1036193,394671,280222,880068,27248,422500,956184,230543,809262,406087,67034,750727,874403,838172,53339,747333,134764,398191,1019412,805604,101796,502987,98136,676815,755811,685418,15869,906250,333573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002992s ]