SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404307 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404307 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25103,387182,493509,427109,384441,353767,1048669,167672,189805,177447,14192,1027635,265007,642032,398163,8823,952,167988,679691,636233,50973,262064,761419,578764,160664,169243,126477,751675,260995,1032075,439370,134597,282669,827718,837186,253096,988907,324041,648709,658902,417958,590445,68131,546748,726627,691498,554587,580283,845856,844764,219126,104977,838182,557923,211595,305954,558050,381996,538296,674221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]