SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504608 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504608 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665627,690162,12126,769881,60447,506226,286087,530952,1039825,562024,811959,879649,778591,310460,873410,968001,834749,924633,182691,245966,1027327,603285,545715,7152,254827,607644,217453,607348,346224,86080,550575,854322,958027,1044735,752568,921660,608815,586697,162537,297402,560904,137615,34530,752279,721738,701312,783816,178058,862048,374529,339679,415177,899116,483259,817794,672675,558222,939317,385121,698056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005336s ]