SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531804 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531804 [ RunTime:0.002144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333322,799974,43171,852456,613095,857034,963394,750880,860604,195372,53828,273717,535433,674008,7579,277367,1007375,917775,635840,280874,859247,665918,337958,799012,612246,831009,1013694,595287,494761,137313,417657,277899,1024926,55068,30286,25022,687503,14226,603580,522672,766206,436770,405027,741205,663320,722857,243727,966023,144905,1016140,928207,1034540,1041050,967984,424492,895585,533217,474223,240912,737131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]