SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142143 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142143 [ RunTime:0.002598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400487,1019979,104039,771070,439481,214890,231435,363497,728527,393590,1013023,228051,334258,121050,350506,559716,469657,485398,304581,118465,651801,912877,875991,977390,119626,653595,429831,373186,836132,55827,665740,150820,797991,837087,36238,767997,49149,611230,178665,1048097,410370,525575,269896,1005530,506156,330403,712883,133841,736707,510694,301451,180264,798829,623543,864014,556718,571309,135126,489834,473474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]