SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510114 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510114 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990570,638951,689348,891663,961006,1011170,428580,484423,417033,148495,872890,414915,475790,885901,158941,612976,682927,315010,971255,926415,528938,1039743,832171,346123,895011,436205,1022775,221427,610659,994210,701121,867899,882209,757537,524906,84709,752268,19863,952875,53797,677409,951768,1039523,1019616,522127,606784,536973,448394,29284,489385,868721,185549,825264,915898,443111,289653,317182,352819,108363,646243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]