SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509648 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509648 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947390,166305,675246,635068,554761,750466,153301,831570,94893,141292,330222,390070,569621,129514,445294,825262,180879,148187,13003,405651,353249,842025,920790,68053,30965,290466,616238,628003,509570,610558,698448,850650,785920,439060,877039,538710,108721,991479,281441,617010,153230,232227,871527,436705,385677,209896,974444,78029,50626,934733,20359,22274,697191,553508,1034251,882344,360718,708898,320377,875537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002325s ]