SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34310 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34310 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14079,139245,555607,96045,471869,366610,655638,821504,102969,485973,330551,834087,711831,53611,124779,130044,714433,62815,568530,699824,274758,572456,140187,177843,537173,238795,608608,834597,209977,62013,513929,292942,836412,168088,341739,907899,333290,601747,925869,94960,861202,575154,155709,790139,69006,182826,832484,440887,1022804,360799,504931,345343,576001,902855,533956,767562,903960,339691,834187,810498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]