SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515314 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515314 [ RunTime:0.003732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165188,367690,506047,366881,870357,56293,86277,240295,971610,396567,790054,289884,851847,248894,402082,684662,188601,615928,427771,1024144,399927,311322,979202,509316,771251,731631,769638,741632,105700,660486,1003205,543302,69323,309809,1014184,570753,372182,908324,392632,472348,644799,55863,853618,900195,683248,1000124,735630,446843,949573,354692,443316,966037,406627,150090,773631,73526,1031418,697332,990219,283065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001053s ]