SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980402 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980402 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180986,939630,149935,366004,980210,204386,5007,56420,66821,506899,992183,891978,160731,485521,709721,107989,441026,1025659,379611,821819,489978,1022484,583432,732909,764331,638114,511479,609539,576692,453026,419448,449808,455289,359798,374675,891242,834690,668910,673124,250254,786801,709363,820273,1013734,732481,818003,373117,492701,779586,391058,248595,361418,146710,854378,140752,1039099,414201,317841,685043,834677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]