SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415920 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415920 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675583,810073,610075,463222,672688,658039,892335,233201,958194,291189,353747,855113,128580,342394,382014,331484,5622,503364,538814,619740,517002,816286,339776,310790,251508,495151,193868,311548,254597,73221,858339,601954,438945,686971,533019,735258,425013,642076,852758,897928,826916,526452,592353,720605,538397,1033255,43524,994398,1009135,934,379768,397554,1030321,847547,321249,1015153,375226,643827,622445,400814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001159s ]