SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318723 LIMIT 1 [ RunTime:0.005422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318723 [ RunTime:0.006385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160083,978185,325238,888652,450693,1038635,594480,209615,904899,632249,61691,940148,502411,352182,986172,805813,130649,1035794,48572,371510,118260,486675,764545,1042706,230686,291856,132935,111755,386937,933942,879067,389335,1009821,324410,46748,578566,269993,9374,823374,431485,625518,314295,406578,859896,21898,55079,191311,724729,981850,523622,504066,685949,665496,988661,652123,298666,755137,867848,114419,601612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000925s ]