SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195325 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195325 [ RunTime:0.008561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542568,406733,329410,480425,447857,1048536,957827,816164,235465,593575,1028694,598990,706899,762810,860585,803952,463402,65640,130984,168657,753858,443698,404477,818582,325798,225466,773005,1042131,987997,789046,448890,65248,1047429,832988,461710,930758,646232,256166,623448,559907,768463,8349,565005,889823,467687,131082,753460,753770,539745,188106,1013407,756940,406361,80155,610556,330396,543370,380165,365492,442628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]