SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 692511 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 692511 [ RunTime:0.003021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197896,105802,791502,655383,521198,931492,508080,826569,66747,669707,700079,129309,451445,315036,774809,291184,527978,558452,942154,417125,819430,180097,734610,835800,491440,14580,750245,446819,691339,33125,939942,5981,890787,805108,284940,257107,342800,1008537,234421,786801,179671,525876,182710,465200,787920,832558,588810,783183,330268,913425,126711,530896,230743,871684,581018,394223,120190,972809,431093,1044590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 692511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 692511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]