SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400720 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400720 [ RunTime:0.003184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317043,65948,1015032,723621,990910,693825,727204,410140,934649,354648,581109,1004019,168879,227906,429675,994321,157372,726449,553674,984502,554016,869711,39001,581195,564653,48241,499282,345157,985549,23558,330427,408635,831449,621719,750537,210863,977648,37260,261445,810712,682925,103894,522370,381348,889458,268465,286970,35561,796835,936489,423812,515394,640310,354339,204413,409724,628214,359170,280155,344194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]