SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317908 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317908 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033386,548664,847556,207364,786876,530725,428928,839567,532810,323391,706305,328511,189232,484196,437721,200268,177854,440572,144859,966197,147766,333352,242273,1014749,108427,949377,637541,267622,347614,570059,952119,245930,961322,493077,817916,276102,846759,670261,1045654,323112,452349,400895,649279,342945,96462,533447,338669,621603,878578,671466,877096,152653,202853,29511,1022479,654294,410407,893243,778226,902779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000952s ]