SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509033 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509033 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2540,172056,114799,1005984,756781,623920,275172,1020184,387331,563476,413051,1041736,287170,909571,396648,940652,181013,1023142,476533,57275,88861,1036684,956505,900003,575494,822881,945510,998954,735503,945345,124585,242293,727705,617960,353462,15073,243529,681079,308045,48290,308239,1033830,408627,441681,325291,557540,825706,1030596,785465,616971,667236,766639,463767,1034429,827778,157161,362056,530842,61679,580275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003264s ]