SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510383 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510383 [ RunTime:0.002098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345410,790402,562172,204184,211525,309009,622120,854294,257221,97150,639505,727079,226949,38302,818851,197357,228276,764094,125061,78656,600642,674898,872649,631466,293607,315824,271285,219592,97842,502463,741617,595760,711883,89095,787330,163100,573105,845495,407167,824367,1037000,127204,546658,715430,992225,432976,853253,644325,60291,827166,127386,708071,271057,577411,309613,297691,968960,596759,220810,94170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]