SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515694 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515694 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943610,340676,409498,847763,941801,980744,288497,378382,878253,289526,966356,514635,586468,121444,386161,186249,797944,504584,333117,985318,994098,667251,262494,774214,118446,426148,783268,24919,218079,59869,406236,721576,377529,507158,618823,199356,959720,870381,708388,691624,212113,121888,842600,619177,952118,697582,592104,922895,670413,693597,345180,557329,491589,499369,82608,820104,811184,34844,569244,870727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]