SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426092 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426092 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109531,509467,72617,1026465,981896,697216,371672,490613,490554,254331,932380,558320,66013,700625,112494,412179,689518,488082,610730,161275,809543,729897,794272,584869,108366,731458,819537,48135,889146,557904,603935,743953,91809,451684,170490,869475,112060,688620,14397,998463,927346,302337,418978,59310,456977,767937,822982,112823,577346,126846,112678,408918,894821,22348,825727,520179,723414,603907,55582,782464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]