SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484475 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484475 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355426,728981,532472,738788,785779,329046,538632,627776,28754,67581,9282,839821,1017672,81370,728272,705816,485446,258203,807956,398179,802444,293353,773496,687206,522694,894225,753086,994930,683282,554397,15313,284360,896101,236483,180716,984841,766539,186957,759038,641804,492478,1022605,442754,104721,416936,226343,731919,625498,659023,256772,835308,811361,488997,338054,822719,18095,74370,849884,14228,933679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000872s ]