SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54570 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54570 [ RunTime:0.003279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047597,272995,712795,321528,911691,386760,962609,391307,737612,869413,1375,1003979,228757,658337,16537,691361,40001,716940,519888,6308,543214,184733,149966,691688,403743,837024,467992,723461,436166,685202,297266,212989,600222,914174,358625,934161,751994,169915,850193,296179,499067,837099,715850,296770,401911,408235,526943,300185,561885,546780,860141,114415,131324,656669,35586,67249,321865,57001,88764,785780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]