SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401376 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401376 [ RunTime:0.003358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202524,413551,181791,880139,632824,859716,217179,229542,480109,15015,565904,157934,923101,619377,476921,478227,258057,320155,494000,697811,687471,966977,574186,971645,943458,710646,243390,611851,334926,178425,96222,424396,434181,907689,821866,966905,805888,434764,61169,916316,767775,1033370,151651,1011477,1033480,932341,745258,536095,208347,446026,657324,108381,811493,671667,1048091,174315,95610,870197,252969,611011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001235s ]