SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412221 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412221 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428851,18268,582662,150465,30061,217613,814621,652902,269951,469925,23204,926844,464169,307219,608773,770522,715024,729459,754400,871052,606596,433123,623774,315828,807486,565619,854338,1008388,431472,349875,361461,105598,939251,912428,64703,312316,132828,732927,564590,734237,23242,595536,490015,814951,457005,563200,854391,398777,746918,900174,1037026,54598,357329,331782,359372,990750,892247,127239,825596,387436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]