SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407512 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407512 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267217,418589,531585,783339,1008384,230826,14397,308863,813953,727125,25097,965485,1024812,62293,857339,1029019,534120,902771,416673,372386,296321,908012,382965,1035660,205543,312194,591648,769075,110840,539955,980157,883261,1025805,387896,751801,138989,190568,10379,534497,20944,10730,970189,366180,522567,272201,4209,818801,91768,511921,595508,533552,879942,504098,966646,648784,432404,640048,946212,380309,788787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]