SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861966 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861966 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635888,344522,3974,1039729,334975,283636,677920,508278,413800,147669,552739,751404,749176,129018,461084,857690,134879,1040067,527221,454615,849483,800849,610888,956127,11051,452191,757828,393652,345839,565785,373606,142899,545308,1029184,242017,606353,973392,957972,251039,274977,225882,585606,742928,972774,268846,728372,147318,605619,757854,684450,625918,133658,310169,861225,150074,38436,688975,952440,25695,323365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001250s ]