SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019812 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019812 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10504,425965,622043,490657,283971,1043528,286711,527105,623386,132769,648575,886447,57755,460184,616472,218779,481786,894452,585694,417777,465641,285436,1039837,129401,381496,451392,331395,31292,387135,1027472,783069,336465,939331,524331,967444,67731,266494,40787,522073,378486,80692,1000186,655373,743949,60658,291366,687256,218925,368400,836676,608068,186116,626223,928828,965474,878759,911918,636377,979874,218050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]