SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499499 LIMIT 1 [ RunTime:0.000996s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499499 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846143,254933,557691,1001406,390948,986494,529756,536731,768808,333733,716513,934118,442459,705335,657089,118169,861904,678909,344834,732435,18579,1004608,284568,764902,558098,439439,869871,636452,578648,462550,237589,475358,924189,183179,126887,1003160,836629,253023,651723,827306,584658,1046970,315014,506893,280729,712680,850036,646351,848889,953889,219142,922271,341797,839982,415175,159471,467593,347026,242234,985748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]