SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387215 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387215 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110827,211552,18614,671462,193016,219561,384232,512964,642996,335743,722271,298765,115694,174438,718478,581088,685336,964675,457127,494394,275919,19179,9303,122769,627836,355588,800965,848843,233658,460475,199395,107396,941398,184052,494874,387354,184059,593664,775493,317813,166005,978283,800332,176097,581407,724412,328259,935580,371875,147960,1026015,386768,620061,50280,334227,651695,63745,323550,181918,175498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001411s ]