SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106521 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106521 [ RunTime:0.002863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038537,726222,447510,706119,661707,46176,729440,682070,297050,56132,255288,433398,362270,175084,1007549,186108,374070,376374,724490,540656,348843,455180,509444,13987,874513,946674,913343,700853,565051,222776,365475,246300,487238,92490,423467,28402,835814,361105,216168,424620,4106,385137,136373,709223,183323,154006,405349,247931,49422,261380,26088,573393,264183,411080,363092,1008288,119168,728722,19645,465673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]