SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 27203 LIMIT 1 [ RunTime:0.000608s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 27203 [ RunTime:0.003873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307459,657522,1002388,716478,680244,168011,834449,789400,461670,284983,118190,533516,766034,927192,759931,429104,223341,611612,267241,829487,333004,656622,18287,549092,911893,787404,888611,50044,767677,1029910,458928,1043318,18075,505880,1023024,233060,629305,818246,546433,626811,494035,456446,725640,275119,601649,249748,202179,564074,276773,735989,80159,317374,811885,468229,189026,1037859,926314,317795,820084,379276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 27203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 27203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]