SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537720 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537720 [ RunTime:0.002563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724219,1018138,182925,184082,347289,481083,926357,703452,373582,696466,59762,988839,771567,183911,77447,935985,734147,401221,683232,183673,206809,120009,106414,106409,610936,253875,702689,1035856,50084,887503,271680,687458,458289,635543,315997,492232,104386,191895,1024731,1036510,820589,649666,944755,212110,338606,576198,378500,86932,243986,211642,272521,115792,710439,713443,700693,494511,744799,693079,532294,795951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]