SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483071 LIMIT 1 [ RunTime:0.001891s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483071 [ RunTime:0.002447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027617,504553,23445,494003,242080,925028,602017,975254,568987,388089,927724,654081,366430,682378,593177,497460,649857,64971,364318,823184,848706,706633,582694,742,426275,28016,389838,420516,1035008,979268,428924,555619,91039,899456,428786,683558,245082,92903,533062,533263,331800,536403,206362,381166,702314,641997,933012,809434,771440,868102,776845,466106,12194,107236,1032451,985929,206775,675799,574449,227368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000698s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]