SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309413 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309413 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413176,134069,301842,696181,881297,355111,386721,1009008,479243,842154,553762,843370,955616,301058,896040,366464,247467,947456,937018,173177,813539,44292,315194,723179,513261,1006074,666659,386370,742947,503564,530988,461339,875775,386627,863812,517555,266823,537025,484869,556188,41672,1018386,227516,405441,613483,950673,213118,356988,695758,848403,216352,790466,789918,339165,301370,813395,650984,199733,159373,611740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]