SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 366189 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 366189 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263814,64719,435547,710440,434477,498431,266869,167470,809073,889306,1047034,1046627,132599,154356,164140,3018,443056,914231,319811,525318,898269,544778,603706,838447,893407,522164,38560,553771,719806,658488,122370,110331,972519,677542,408966,759844,653048,666715,839921,349980,939525,629619,344483,218404,150088,1007184,388191,15904,944897,534592,263183,786150,692025,339767,354694,424619,481362,445271,312430,623671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 366189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 366189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]