SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319081 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319081 [ RunTime:0.003511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816008,984966,710689,61271,359003,523916,601506,410697,493521,511351,576906,888096,233366,95444,722916,250330,217421,435020,210269,887283,60087,227350,114343,690982,833537,498793,806951,1030395,626345,968950,362307,325806,665694,142820,9399,881929,774864,296183,303980,785525,727608,852983,943121,707348,98681,170958,970655,110349,373268,426550,463618,654728,399584,948093,963114,325451,441024,1017007,842440,279819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]