SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486618 LIMIT 1 [ RunTime:0.004021s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486618 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141729,565485,108277,320606,546812,377873,460043,539659,634280,454403,372213,785991,410026,419529,813257,1033751,427402,905191,435180,484977,15111,605578,712821,685002,99671,563834,246507,695630,996963,317329,880755,1017260,966778,449366,122883,36402,988228,815,551919,381742,851144,802672,680149,276973,459979,755524,932352,101544,164512,569072,96126,852443,160624,661487,170719,395400,448017,456719,198982,670751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000875s ]