SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40318 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40318 [ RunTime:0.002356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326678,573795,446883,475952,335368,439305,685577,809413,398441,878648,69472,766901,69387,864976,664092,381883,37618,116091,774091,55046,937118,153573,486896,696544,332047,275217,324042,159174,650740,874257,811018,291548,526690,127869,948777,484292,493810,802227,145096,721861,343207,57083,780735,767808,250836,558956,600355,428449,345122,932819,105792,997130,319804,607298,672147,314148,987716,848696,1015869,355995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]