SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415089 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415089 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405934,757685,688463,750318,751301,130385,816291,705949,299506,905909,681436,405632,1030478,315920,52005,595189,1000256,770989,575856,145744,755943,440798,740540,36701,706311,978687,421201,988374,160472,410915,758383,837393,809640,908218,522542,832283,617514,309301,663973,318097,459307,494226,880672,33235,116653,427624,616362,754258,735427,871469,608874,616905,765089,594759,964330,456963,767965,720792,871373,498260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]