SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517128 LIMIT 1 [ RunTime:0.002768s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517128 [ RunTime:0.006864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226163,24331,850614,452142,654726,435071,984512,1006693,860384,679831,924592,741801,461316,1045958,557536,732864,886689,405217,585610,1035603,767526,507023,885122,11575,466725,895460,664870,14056,972129,215759,107337,925618,128010,44578,86726,167319,674979,271398,777071,1025573,341513,421447,369134,878576,100732,220821,342376,844154,628473,843318,291497,178169,879916,953853,458946,86906,611823,384921,712725,748136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000843s ]