SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017939 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017939 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98791,1045398,909518,990730,426964,422149,272667,319767,189317,53561,712854,534748,197429,918009,759432,324487,1011312,421875,441710,441546,824129,288331,434034,806621,260646,1043980,642662,989969,798928,622783,560692,166916,698113,898269,57841,30373,62208,1005269,161158,996199,810821,382796,205162,923664,205507,918887,1042602,453094,976943,686951,470925,563462,460180,961869,467289,777865,675978,1016645,472597,463864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000784s ]