SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504819 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504819 [ RunTime:0.003998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425278,352288,878434,428491,717056,596356,281384,799813,781867,192397,411985,972783,557380,202700,69159,597960,13637,269040,815902,448307,188493,548219,368008,839004,600850,734774,1040755,947532,910659,128484,562325,515824,520059,506135,506158,984228,805192,615920,318111,326570,146996,863521,116850,417747,965681,808191,1048115,798173,892886,695290,375203,297651,552332,170926,617060,456430,1017046,627753,730461,128286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000809s ]