SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484609 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484609 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199101,137240,576478,26810,1020446,430091,628608,262714,404193,943423,436228,97592,800384,541470,957719,324669,430590,351255,1023853,39174,83488,447531,832859,277320,421726,948856,506330,1025698,279134,199519,480522,980036,780626,549475,513606,827845,180728,858895,389382,709648,621691,106780,209081,739126,564700,840858,685188,302005,65620,794632,226117,844313,939599,48561,843445,129503,346499,523035,737915,342420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]