SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534389 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534389 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475050,884243,976354,379805,137616,232579,1036023,522964,969304,608114,719320,971516,722348,541109,21762,930505,658791,212899,950813,203416,124820,285945,626985,785678,386726,1048707,712365,248198,378488,832578,241769,878314,902571,684584,962913,140110,161179,564027,879161,900617,582999,186000,254753,327693,886262,981541,6155,748051,455045,222817,304798,468138,379028,189881,180216,279962,992166,705153,829697,397729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]