SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511696 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511696 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396750,642831,50116,248704,121174,156393,556436,430094,699172,73367,546446,854711,646200,408674,699714,115818,541127,462067,967968,969559,464195,844985,84039,641152,10906,83820,106012,787974,161816,1018493,652203,202611,977543,567363,40177,159483,96363,296706,70915,409707,341078,174871,349956,325206,562153,1013746,1042360,588446,802470,738888,774977,184599,815346,134288,190596,257590,128717,411778,898339,333733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000935s ]