SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003861s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195050 LIMIT 1 [ RunTime:0.001867s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195050 [ RunTime:0.003693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653341,475333,267042,566799,405378,99128,569421,412012,184181,897151,82881,892649,6609,315280,664266,904360,157908,377951,524428,101030,820593,223184,463220,305821,501959,343611,889049,827377,428849,178073,494046,356215,1001320,577547,785138,763995,948831,336312,84913,389282,556164,673325,784951,169204,856014,69678,136223,887488,339578,853497,802125,657850,125549,1009129,944157,20298,1042091,382214,407863,74102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]