SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201311 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201311 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413337,194254,475459,603781,479706,262159,96903,1037500,517964,15987,680188,552618,1063,1039941,418811,688567,563638,363514,390994,932358,892403,36849,996941,754245,912128,621515,527926,93041,613918,485739,992496,857645,333861,630802,572605,91608,734510,949003,970883,857430,180017,830126,32294,192684,378866,129251,884584,65761,957543,559187,50368,268903,460207,642411,172999,14399,383550,139556,83435,58328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]