SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300213 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300213 [ RunTime:0.002353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683324,189514,277637,747455,376716,477508,183578,131023,455731,453433,396254,880038,1039943,432375,959642,193306,847993,1036333,291088,259361,718869,1032449,1008966,157032,563394,494423,609473,824675,842999,1024507,670527,243004,764894,725486,277454,115509,349390,465328,93110,381882,645563,95239,75469,324155,132721,254053,533327,59045,1033453,250951,2036,743575,631944,604634,913603,961495,236840,691764,233673,584013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000950s ]