SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483925 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483925 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17896,189222,622746,51902,865414,131464,414942,884332,221815,288267,739620,326769,474642,21038,317183,860530,424466,401437,40416,265685,926084,380040,701315,43536,908658,856839,919345,585343,570228,984796,187632,512765,704792,1029856,270172,331310,988177,1940,465850,53870,32080,603336,499087,418494,383459,557544,508172,519793,501709,101395,370068,234166,495569,171059,198073,76085,70506,681027,68100,478684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483925 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483925 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]