SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200711 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200711 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445822,326784,171293,285831,843971,403866,633043,222923,41525,254700,441157,155049,179516,830330,1025896,724554,240901,947042,161345,235049,747208,95289,614352,68480,686172,936202,299241,994988,991448,166287,262688,919403,81525,122249,800719,1024077,893603,49386,1017744,1033540,235192,796333,496570,877959,46324,669942,930838,625570,279383,1000301,81611,149320,963840,429808,67011,519693,345455,79002,481855,938460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001316s ]