SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002899s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043885 LIMIT 1 [ RunTime:0.001199s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043885 [ RunTime:0.005440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140690,382117,125821,299449,173953,947395,43802,94849,227557,750830,239769,606457,224897,478642,94979,402687,95933,24629,41355,92444,979036,441984,211370,880095,866214,292005,315643,81304,20107,534756,489887,464887,488147,122254,413036,315393,96794,238712,257592,160167,402427,717945,623894,67522,834001,670730,620630,290717,357032,974884,715464,1040068,392160,372334,122258,37668,122106,503637,462589,134108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043885 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043885 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]