SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000146 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000146 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210436,733361,463448,247821,561920,102080,656260,825248,243430,620161,736126,357627,524248,248446,122369,422415,539041,187376,517241,822538,379006,497516,127268,691148,298720,176921,536694,211075,725018,658180,600974,28313,945798,185860,62184,132135,814809,600689,36584,846584,430457,635221,622394,825441,735851,239452,97820,141704,174882,329636,787631,880580,727044,342740,761793,340596,646301,290642,642718,112335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]