SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291821 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291821 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486133,413199,778179,301466,273450,1013507,304330,980054,95244,640656,473662,1039144,494610,23525,921794,426813,648696,577100,1044450,16093,143160,491531,1027979,889357,439783,635723,440139,880298,1016214,563477,266422,334850,646227,925737,2983,18168,72379,924052,887072,441049,524527,78052,655417,897664,1017295,847606,867350,76715,482851,404422,35656,292844,898922,129861,430192,139770,406540,612035,836180,205156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]