SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002010s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5985 LIMIT 1 [ RunTime:0.004082s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5985 [ RunTime:0.002630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186274,858283,571531,595799,470958,567616,746187,901074,522610,623597,724375,1003520,613234,958773,807499,500109,568619,717115,995286,904090,313577,463193,221914,824231,1040321,708218,35927,314724,604227,999218,883802,596718,840280,243043,417697,845044,614258,407820,372472,634269,359492,386778,114194,203476,842566,313588,215524,575729,709582,155803,150396,345646,583946,576471,155499,572639,1040140,434176,44322,859423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003862s ]