SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416059 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416059 [ RunTime:0.004572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471150,371874,230660,490910,1022934,170548,87504,354814,308443,383437,804780,476148,137807,358540,480097,1004408,451632,645818,20019,507736,80796,682264,657094,508141,586209,1028497,292359,571785,379799,747837,750109,61118,133696,812266,509666,961457,192914,1025024,768523,503069,653290,62315,630114,543034,736210,439839,849667,1044723,968676,57589,554277,52204,129524,969181,757110,563755,395761,273779,83760,462234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]