SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401473 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401473 [ RunTime:0.003053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484842,613848,36869,810594,16525,341184,1045334,721338,46592,395696,947549,552060,750145,375914,172701,522155,998962,577328,215420,438019,860295,728196,367090,439619,474162,358799,263807,895536,610568,892519,718180,412714,532792,592960,873277,384357,373598,313953,258760,507369,1010228,184688,320900,312201,407386,162737,234741,51767,705714,1011214,827345,69841,920272,597847,872780,331835,70691,484754,225935,974263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001501s ]